UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rbDD03QPnv/+efgh4MThEoySTBfOY8REAqL7vlo8zBs='
WHERE
key_id = 'a6f4fc4a7de3ea927c4c06c6c36d94a3723e8b718c851664d847936461a72f22'
AND (
token = 'rbDD03QPnv/+efgh4MThEoySTBfOY8REAqL7vlo8zBs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)