UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6sVTcro4hH1dsZUqh0tk0CgPOIciR7o6pX8+VI+eKNg='
WHERE
key_id = '9a88e23d6d80819a09670e9add03ce624f9d93e063055a2df43e3f14876451a0'
AND (
token = '6sVTcro4hH1dsZUqh0tk0CgPOIciR7o6pX8+VI+eKNg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)