UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6HEZcjtIAkuWMzya7e6ls3BV4eiLpk7UpK448EPp7Mk='
WHERE
key_id = '48b63258ac7c1f7632e7d7be8c97a45d741e55c5b92d830ebf6a704f3a803b8f'
AND (
token = '6HEZcjtIAkuWMzya7e6ls3BV4eiLpk7UpK448EPp7Mk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)