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