UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D5SnmzqgLp88J7BEX5vM08K+DH6lF7S1AWyt28iIsF0='
WHERE
key_id = '9474437b06671a29157c9a297bb21271fc0507305b85c02b72b436f8b99899a4'
AND (
token = 'D5SnmzqgLp88J7BEX5vM08K+DH6lF7S1AWyt28iIsF0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)