UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'smjJm5CcMm471TjT41tBwAn/+nD3wIV4lCCokvAbBTU='
WHERE
key_id = '6233ab926e1bc6a5c9c2a2cb0dc011296b08f74e94894ea986e35e9715376b4a'
AND (
token = 'smjJm5CcMm471TjT41tBwAn/+nD3wIV4lCCokvAbBTU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)