UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3O5rnHR7PXf3Ki4IaGFKlwgn0fSd5bfSge9Hp46lV8M='
WHERE
key_id = 'ae016b804fe3e311717c129fdc72c9ea3365bae3f0cc81ddbb1def08d61ec4e3'
AND (
token = '3O5rnHR7PXf3Ki4IaGFKlwgn0fSd5bfSge9Hp46lV8M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)