UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Orsehj+ZQkXPpwYRf/csKE7sT6lNrYV6IDDXrflwk8A='
WHERE
key_id = '0c3e930d97640c4da7360a8fddd58751e6e95099f5314333d36a360df87fa4f8'
AND (
token = 'Orsehj+ZQkXPpwYRf/csKE7sT6lNrYV6IDDXrflwk8A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)