UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XwW54d9WUr3TYXs+oZA7ZMEQv0gWzjOmM4tLag0pKsY='
WHERE
key_id = 'e9b4044e59f4ac5d43024e9bdc80536f256ba8693db9435908540cf20b6d8df2'
AND (
token = 'XwW54d9WUr3TYXs+oZA7ZMEQv0gWzjOmM4tLag0pKsY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)