UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hmD21lZyN6mY8ASw+4fXAmmU8F6rwNdXtl66ugS5MKg='
WHERE
key_id = '0b8b75c3f93c43c43ac60cc6aceca894ddb3d81b48151b503b3cf9c760673333'
AND (
token = 'hmD21lZyN6mY8ASw+4fXAmmU8F6rwNdXtl66ugS5MKg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)