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