UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '18nYriZN9RycGpIb6o0iB9hU+TN8oe0psTq8syaZKtk='
WHERE
key_id = 'bc9baf3a9aa16dbbb9d6b557c7e471e9e1e5c04afa17c1ac8c78ab8ebfd0c4ed'
AND (
token = '18nYriZN9RycGpIb6o0iB9hU+TN8oe0psTq8syaZKtk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)