UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xjpkqwvsOQZbuLfUV+V0da5A7BbiEBmRD/aGfisohGw='
WHERE
key_id = 'fd0471986f1add01760b82475aeadbfe4ae575ca982e75f0a050bd58f5617260'
AND (
token = 'xjpkqwvsOQZbuLfUV+V0da5A7BbiEBmRD/aGfisohGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)