UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z+JtXuQGinZjFokEYFOJjmPM/bwBOqOnmBuSHz6hqss='
WHERE
key_id = 'a9b9346b3fe4a81013a7a52eaf49eb09a37b409b1d65c28aab83deaa737d818a'
AND (
token = 'Z+JtXuQGinZjFokEYFOJjmPM/bwBOqOnmBuSHz6hqss='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)