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