UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZZ7l/gL2ujpa3YS+/FGF/7dstmonxyZHkrV6l+USIuk='
WHERE
key_id = 'f31a21de80c03e9687c3a077e239e65cefa88590b1d9abc5cf076fc5f9fa2602'
AND (
token = 'ZZ7l/gL2ujpa3YS+/FGF/7dstmonxyZHkrV6l+USIuk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)