UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bgzf1fk///chi4vu9ZILxMFUqFhpAnMiDN7M2KQ1V98='
WHERE
key_id = 'b1463d3489bf5306f866db0990bf3fc2f048ece91fdb8c33e3c9d1077c5adf3a'
AND (
token = 'Bgzf1fk///chi4vu9ZILxMFUqFhpAnMiDN7M2KQ1V98='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)