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