UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm9L6cJvjtHKLZUxnqF3QJ+QJWgTUF5D7RFiZa+Rf9xs='
WHERE
key_id = '9d27667c9787aed98ff94fcea1bb0ab408dbf31959d27f3961cdfc58832c63e0'
AND (
token = 'm9L6cJvjtHKLZUxnqF3QJ+QJWgTUF5D7RFiZa+Rf9xs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)