UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Xu6ZO7DZ2pfx2I81hLi3Ov4Rkqnv17JI1yXunyE0a8='
WHERE
key_id = 'a3cc5c04a76cc52c80abe6ee3e8edca033acfbcde31b092c9b6f199c7892e839'
AND (
token = '9Xu6ZO7DZ2pfx2I81hLi3Ov4Rkqnv17JI1yXunyE0a8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)