UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YB3TJI74w+rr1GSRT/W6bQJpRoiE1NFWuQBFyEtCAFs='
WHERE
key_id = '478499c47bd45b3166024c7fba93f6af9e94707d14351ac9bbef247d6c9bf405'
AND (
token = 'YB3TJI74w+rr1GSRT/W6bQJpRoiE1NFWuQBFyEtCAFs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)