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