UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '480TEepSm9+QxyrhOxGnhlC/RGlgB7HiKbnqK2PU+rA='
WHERE
key_id = 'bc398e9f5828b8fd4c7a88365d329250f9b72021df7172f8f69858e1666604f0'
AND (
token = '480TEepSm9+QxyrhOxGnhlC/RGlgB7HiKbnqK2PU+rA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)