UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V1vbqX9lEVa3odWbsT5y7EnoXtePC+Sb9rXXZh91IyU='
WHERE
key_id = '8305e4b89d1ed553fd30d07afba6c2505e7f53b3d9c058fcb23498d3bc3abd92'
AND (
token = 'V1vbqX9lEVa3odWbsT5y7EnoXtePC+Sb9rXXZh91IyU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)