UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9ZcPnJLzwek9ZjJtnd89oxglpOBEM7LWynL8okT21B0='
WHERE
key_id = '22ffc3b6c92cb0aee790e85f4ec682f6b04831181bc65bb894e83519d7c5161c'
AND (
token = '9ZcPnJLzwek9ZjJtnd89oxglpOBEM7LWynL8okT21B0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)