UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HQ+QKU4qOyJ+9Ipie/DtTjgxwuCe7T4d76QdeI3SeCY='
WHERE
key_id = '0a0cc25a599e243f7a1401b7a64f6b680798553899979528874ae2bd3ca67505'
AND (
token = 'HQ+QKU4qOyJ+9Ipie/DtTjgxwuCe7T4d76QdeI3SeCY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)