UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NnA2gjoUHgqSyZg8yWNr9BM9XiVFlG9DmWYtbvpU7Ps='
WHERE
key_id = 'd8af9b97016161d8cdd0fc9654da3ddca99d7a91e89a90b0744149a1cd0c9f8e'
AND (
token = 'NnA2gjoUHgqSyZg8yWNr9BM9XiVFlG9DmWYtbvpU7Ps='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)