UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N6DENjCNayM13jI3yVsjqnQVVZUD1SMxjHcEV2xSkq4='
WHERE
key_id = '3584a98aae42065e287a662740c6b32d8c3134f18b04ef57cab73691adc8828d'
AND (
token = 'N6DENjCNayM13jI3yVsjqnQVVZUD1SMxjHcEV2xSkq4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)