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