UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PGvutgITETjY4nGkfoNNrc3SBNU128u2RJZ1F97wvqw='
WHERE
key_id = '416ca604b1b6d8adf7a635f8291c6499cd16b8babd3ba8307dfe525e93226e2f'
AND (
token = 'PGvutgITETjY4nGkfoNNrc3SBNU128u2RJZ1F97wvqw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)