UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bp4MpVEX9cp7iW1juIs2ugKFplk1N7PvZj2mFSSR+yU='
WHERE
key_id = '8c2af84fd1ed22834f8bbbd19879dd8818c12cd83c72a9dcdcbf9a00a772c9ed'
AND (
token = 'bp4MpVEX9cp7iW1juIs2ugKFplk1N7PvZj2mFSSR+yU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)