UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pmo6kr70S8QnsouwThMfkEbTwZ0d8T5l9Gmg1stAsQw='
WHERE
key_id = 'ec0ac04bb2caa306d3dfe4ed0341bc056b4212845e426528a9300c62fbcf1765'
AND (
token = 'pmo6kr70S8QnsouwThMfkEbTwZ0d8T5l9Gmg1stAsQw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)