UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zRxGIfj95+RAUrFEx8gzi+iFeZHtYznozOaW1HkMCnA='
WHERE
key_id = '25ad1f77c20400dd764a19d96e75477a94d4f1bdfa81e49e9f7f32c3ceb97fc6'
AND (
token = 'zRxGIfj95+RAUrFEx8gzi+iFeZHtYznozOaW1HkMCnA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)