UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZNJBIjugX1Hd6dnIuAcoGBLwSA6AqpbU8JiLp8X2vus='
WHERE
key_id = '58a334b42a2ee70edb2638c87224b94ebf8a8003f9fe1a8473ce77bde2c70340'
AND (
token = 'ZNJBIjugX1Hd6dnIuAcoGBLwSA6AqpbU8JiLp8X2vus='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)